I am new to Python and SQL. I have been tasked with creating a call logging interface for logging IT support calls. I have watched your tutorials on SQL Lite but was wondering how you would go about adding data to an SQL data base from answers to specific questions put to a user.
The sort of questions I intend to use are...Date, Server Host Name, Fault, Case ID etc.
So the answers to the questions would then populate the SQL database and would then be able to me searched etc.
Any help with this would be much appreciated. As I say I am new to both Python and SQL but am learning fast.
Regards and thanks,
Darren
You must be logged in to post. Please login or register an account.
I am not sure why you'd want to manually enter the data, but you can just either write the raw sql query manually, or you can create a simple UI that uses the input() function to get the inputs you want, then do a typical sql insert from there.
user input tutorial: https://pythonprogramming.net/user-input-python-3-tutorial/
-Harrison 8 years ago
You must be logged in to post. Please login or register an account.